package com.fottas.adware.portal.dao;

import com.fottas.adware.model.TmsTask;
import com.fottas.adware.model.TmsTaskCategory;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface TaskDao {

    @Select("select id,product_price as productPrice,commission,stock,details from tms_task where id=#{id}")
    TmsTask task_DetailsBld(@Param("id") int id);

    //查询所有的分类
    @Select("select * from tms_task_category")
    List<TmsTaskCategory> getAllTaskCategory();

}
